<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@page import="com.jdbc.Jdbc"%>
<%@page import="java.sql.*"%>
<%@page import="com.project.bean.*"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<%
	//首先判断这个等级日期是否已经登记过使用

	String classname = request.getParameter("classname");
	String centername = request.getParameter("centername");
	String checkdate = request.getParameter("checkdate");
	//判断是否已经有了这个日期的选择
	//首先先判断这个日期有没有已经存在在checkdate中了主键就是centername,classname,date三个共同组成
	//这里只负责搜索，插入具体的日期应该交到后台提交数据之后
	//防止操作人员在此处就将页面关闭，导致检查的日期已经等级但是具体信息还是没有插入进去
	// 先将这个考察日期存储到checkdate表中去，就是存储这天已经考勤过了

	String select = "select * from checkdate where classname='" + classname + "' and centername='" + centername
			+ "' and date='" + checkdate + "'";
	try {
		Jdbc checkdate1 = new Jdbc();
		checkdate1.Jdbc_Q2(select);
		//注意此处要把光标移到下一行才能读取数据
		checkdate1.rs.first();
		String c = checkdate1.rs.getString("classname");
		System.out.println(select);
		if (c != null && c.equals(classname)) {
			//表示这个日期已经检查过了
			request.getRequestDispatcher("showcheckdateyet.jsp").forward(request, response);
			return;

		}
	} catch (ClassNotFoundException | SQLException e1) {
		// TODO Auto-generated catch block

	}
	String[] b = checkdate.split("-");// 并且将2018-01-13转换为2018年01月13号
	String c = b[0] + "年" + b[1] + "月" + b[2] + "日";
	//=================================================================
	String find = "select*from stu_class where classname='" + classname + "' and centername='" + centername
			+ "'";
	Jdbc j = new Jdbc();
	ResultSet rs;
	List<Stu_class> list = new ArrayList<>();
	j.Jdbc_Q2(find);
	rs = j.rs;

	while (rs.next()) {
		Stu_class sc = new Stu_class();
		sc.setStuid(rs.getString("stuid"));
		sc.setChinesename(rs.getString("chinesename"));
		sc.setCentername(rs.getString("centername"));
		sc.setClassname(rs.getString("classname"));
		list.add(sc);

	}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>

<head>
<meta charset="utf-8">
<title>班级签到表</title>
<meta name="renderer" content="webkit">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport"
	content="width=device-width, initial-scale=1, maximum-scale=1">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="format-detection" content="telephone=no">
<link rel="stylesheet" href="./css/x-admin.css" media="all">
</head>
<body>
	<div class="x-nav">
		<span class="layui-breadcrumb"> <a><cite>首页</cite></a> <a><cite><%=checkdate%>签到管理</cite></a>
		</span>
		<!--             <a class="layui-btn layui-btn-small" style="line-height:1.6em;margin-top:3px;float:right"  href="javascript:location.replace(location.href);" title="刷新"><i class="layui-icon" style="line-height:30px">ဂ</i></a>
 -->
	</div>
	<div class="x-body">
		<form class="layui-form x-center" action="" style="width: 500px">
			<div class="layui-form-pane" style="margin-top: 15px;">
				<div class="layui-form-item">
					<div class="layui-input-inline" style="width: 400px"></div>
					<div class="layui-input-inline" style="width: 80px"></div>
				</div>
			</div>
		</form>
		<form method="post" action="checkintime">
			<xblock> 当日课时<select name="classtime" id="id"><option
					selected="1">1</option>
				<option value="1">1</option>
				<option value="1.5">1.5</option></select> 注意：一旦登记为”出勤“状态后将无法更改，请仔细检查</xblock>
			<table class="layui-table">
				<thead>
					<tr>

						<th>学号<input type="hidden" name=count value=<%=list.size()%>></th>
						<th>中文姓名<input type="hidden" name=checkdate
							value=<%=checkdate%>></th>
						<th>当日考勤</th>
					</tr>
				</thead>
				<tbody>
					<%
						for (int i = 0; i < list.size(); i++) {
					%>
					<tr>

						<td><input type=text name=<%="stuid" + i%>
							value=<%=list.get(i).getStuid()%> readonly><input
							type="hidden" name="centername"
							value=<%=list.get(i).getCentername()%>> <input
							type="hidden" name="classname"
							value=<%=list.get(i).getClassname()%>></td>
						<td><input type=text name=<%="stuname" + i%>
							value=<%=list.get(i).getChinesename()%> readonly></td>

						<td><select name=<%="check" + i%>>
								<option selected="selected" value="0">请选择出勤状态(默认未出勤)</option>
								<option value="1">出勤</option>
								<option value="0">未出勤</option>
						</select></td>

					</tr>


				</tbody>
				<%
					}
				%>
				<button class="layui-btn" lay-filter="add" lay-submit="">
					登记</button>
			</table>
		</form>

		<!-- <div id="page"></div> -->
	</div>
	<br />
	<br />
	<br />
	<script src="./lib/layui/layui.js" charset="utf-8"></script>
	<script src="./js/x-layui.js" charset="utf-8"></script>
	<script>
		layui.use([ 'laydate', 'element', 'laypage', 'layer' ], function() {
			$ = layui.jquery;//jquery
			laydate = layui.laydate;//日期插件
			lement = layui.element();//面包导航
			laypage = layui.laypage;//分页
			layer = layui.layer;//弹出层

			//以上模块根据需要引入

			laypage({
				cont : 'page',
				pages : 100,
				first : 1,
				last : 100,
				prev : '<em><</em>',
				next : '<em>></em>'
			});

			var start = {
				min : laydate.now(),
				max : '2099-06-16 23:59:59',
				istoday : false,
				choose : function(datas) {
					end.min = datas; //开始日选好后，重置结束日的最小日期
					end.start = datas //将结束日的初始值设定为开始日
				}
			};

			var end = {
				min : laydate.now(),
				max : '2099-06-16 23:59:59',
				istoday : false,
				choose : function(datas) {
					start.max = datas; //结束日选好后，重置开始日的最大日期
				}
			};

		});

		//批量删除提交
		function delAll() {
			layer.confirm('确认要删除吗？', function(index) {
				//捉到所有被选中的，发异步进行删除
				layer.msg('删除成功', {
					icon : 1
				});
			});
		}
		/*用户-添加*/
		function user_management_add(title, url, w, h) {
			x_admin_show(title, url, w, h);
		}
		/*用户-查看*/
		function user_management_show(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}

		/*用户-停用*/
		function member_stop(obj, id) {
			layer
					.confirm(
							'确认要停用吗？',
							function(index) {
								//发异步把用户状态进行更改
								$(obj)
										.parents("tr")
										.find(".td-manage")
										.prepend(
												'<a style="text-decoration:none" onClick="member_start(this,id)" href="javascript:;" title="启用"><i class="layui-icon">&#xe62f;</i></a>');
								$(obj)
										.parents("tr")
										.find(".td-status")
										.html(
												'<span class="layui-btn layui-btn-disabled layui-btn-mini">已停用</span>');
								$(obj).remove();
								layer.msg('已停用!', {
									icon : 5,
									time : 1000
								});
							});
		}

		/*用户-启用*/
		function member_start(obj, id) {
			layer
					.confirm(
							'确认要启用吗？',
							function(index) {
								//发异步把用户状态进行更改
								$(obj)
										.parents("tr")
										.find(".td-manage")
										.prepend(
												'<a style="text-decoration:none" onClick="member_stop(this,id)" href="javascript:;" title="停用"><i class="layui-icon">&#xe601;</i></a>');
								$(obj)
										.parents("tr")
										.find(".td-status")
										.html(
												'<span class="layui-btn layui-btn-normal layui-btn-mini">已启用</span>');
								$(obj).remove();
								layer.msg('已启用!', {
									icon : 6,
									time : 1000
								});
							});
		}
		// 用户-编辑
		function user_management_edit(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}
		/*密码-修改*/
		function user_management_password(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}
		//删除用户
		function user_management_delete(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}
		/*用户-删除*/
		function member_del(obj, id) {
			layer.confirm('确认要删除吗？', function(index) {
				//发异步删除数据
				$(obj).parents("tr").remove();
				layer.msg('已删除!', {
					icon : 1,
					time : 1000
				});
			});
		}
	</script>
	<script>
		var _hmt = _hmt || [];
		(function() {
			var hm = document.createElement("script");
			var s = document.getElementsByTagName("script")[0];
			s.parentNode.insertBefore(hm, s);
		})();
	</script>
</body>
</html>
